Home > Download > SMU - Question Paper
> BSc IT > BT0066
Database Management Systems
This is the collection of
Sikkim Manipal University (SMU) question and answers for Database Management Systems . It will help
to prepare your examination. All question paper are
classified as per semester, subject code and question type of Part A, Part B and Part C with
multiple
choice options
as same as actual examination. SMU question papers includes
year 2025, 2024, 2023 Sem I, II, III, IV, V, VI examinations
of all subjects.
SMU question test set of old,
last and previous year are updated
regularly and it is absolutely free to use. Question paper includes Visual basic 6, VB.Net, C#, ASP.Net,
Web, Oracle, Database, SQL, Software Engineering, C, C++, OOPS, MBA, MCA, BSC IT I have requested
you kindly send me the question paper of Database Management Systems , SMU - Bachelor of Science in Information Technology.
Course Name
BSc IT (Bachelor of Science in Information Technology)
Subject Code BT0066 (Database Management Systems )
Get Questions
PART - A
PART - B
PART - C
Subject : Database Management Systems
BT0066 : PART - C
Q. 1 | What are the features of Magnetic tapes 1. The transfer rate between the device & memory is at speeds of 50 to 300 KBytes per second 2. The tape is moved when a read/write operation is initiated 3. Here the data can be recorded in high densities 4. A file stored on tape can either be in input mode or in output mode. 5. The device permits direct access to stored data by specifying the address of block or sector containing the data |
| A) | 1, 2,3,4,5 |
| B) | 2, 3, 4, 5 | | C) | 1,3,4,5 | | D) | 1, 2, 3, 4 | | | | Q. 2 | Give the reason for the popularity of the client-server architecture? a) applications distributed data and applications b) need for graphical user interface for end users. c) removes the computing load for presentation services from the system managing a shared database resource d) more powerful workstations on LANs e) Process share common data structures like lock table, dead lock detection, scheduling are performed by an operating system. |
| A) | a), b), c), d) and e) |
| B) | a), c) and e) | | C) | b), and e) | | D) | a), b), c) and d) | | | | Q. 3 | Match the following SET A i. Master ii. Model iii. Msdb iv. Tempdb SET B a. records all of the system level information for a SQL Server system b. is used as the template for all databases created on a system. c |
| A) | i – a, ii – b, iii – c, iv – d |
| B) | i – b, ii – c, iii – d, iv – a | | C) | i – c, ii – d, iii – a, iv – b | | D) | i – d, ii – a, iii – b, iv – c | | | | Q. 4 | Match the following types of access methods with their description Set A 1. HSAM 2. HISAM 3. HDAM 4. HIDAM Set B a. an index based access is permitted for the root record b. the random access to root records is provided using an index. c. direct access to the root records is provided using hashing & chaining method d. child record of a particular parent are stored consecutively after the parent itself |
| A) | 1 - a, 2 - d, 3 - c, 4 - b |
| B) | 1 - a, 2 - c, 3 - d, 4 - b | | C) | 1 - d, 2 - b, 3 - c, 4 - a | | D) | 1 - d, 2 - a, 3 - c, 4 - b | | | | Q. 5 | To locate required block on a track is called latency time. It is also known as ______ |
| A) | Seek-time |
| B) | Rotational delay | | C) | Rotational Time | | D) | Transfer Rate | | | |
Click here to get
Database Management Systems (BT0066 )
New Question
Home > Download > SMU - Question Paper
> BSc IT > BT0066